Requirement already satisfied: sklearn in ./venv/lib/python3.10/site-packages (0.0.post1) [notice] A new release of pip available: 22.2.2 -> 23.0 [notice] To update, run: pip install --upgrade pip
Requirement already satisfied: squarify in ./venv/lib/python3.10/site-packages (0.4.3) [notice] A new release of pip available: 22.2.2 -> 23.0 [notice] To update, run: pip install --upgrade pip
/home/ayush/Documents/Project/ayush/customer_segm_RFM
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | |
|---|---|---|---|---|---|---|---|---|
| 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 12.1.10 8:26 | 2.55 | 17850.0 | United Kingdom |
| 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 12.1.10 8:26 | 3.39 | 17850.0 | United Kingdom |
| 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 12.1.10 8:26 | 2.75 | 17850.0 | United Kingdom |
| 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 12.1.10 8:26 | 3.39 | 17850.0 | United Kingdom |
| 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 12.1.10 8:26 | 3.39 | 17850.0 | United Kingdom |
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 541904 | 581587 | 22613 | PACK OF 20 SPACEBOY NAPKINS | 12 | 12.9.11 12:49 | 0.85 | 12680.0 | France |
| 541905 | 581587 | 22899 | CHILDREN'S APRON DOLLY GIRL | 6 | 12.9.11 12:49 | 2.10 | 12680.0 | France |
| 541906 | 581587 | 23254 | CHILDRENS CUTLERY DOLLY GIRL | 4 | 12.9.11 12:49 | 4.15 | 12680.0 | France |
| 541907 | 581587 | 23255 | CHILDRENS CUTLERY CIRCUS PARADE | 4 | 12.9.11 12:49 | 4.15 | 12680.0 | France |
| 541908 | 581587 | 22138 | BAKING SET 9 PIECE RETROSPOT | 3 | 12.9.11 12:49 | 4.95 | 12680.0 | France |
541909 rows × 8 columns
Timestamp('2011-12-09 12:49:00')
InvoiceNo object StockCode object Description object Quantity int64 InvoiceDate datetime64[ns] UnitPrice float64 CustomerID float64 Country object dtype: object
2011-12-10 00:00:00
| InvoiceNo | StockCode | Description | Quantity | InvoiceDate | UnitPrice | CustomerID | Country | TotalSum | Frequency | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 536365 | 85123A | WHITE HANGING HEART T-LIGHT HOLDER | 6 | 2010-12-01 08:26:00 | 2.55 | 17850.0 | United Kingdom | 15.30 | 373 days 15:34:00 |
| 1 | 536365 | 71053 | WHITE METAL LANTERN | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 373 days 15:34:00 |
| 2 | 536365 | 84406B | CREAM CUPID HEARTS COAT HANGER | 8 | 2010-12-01 08:26:00 | 2.75 | 17850.0 | United Kingdom | 22.00 | 373 days 15:34:00 |
| 3 | 536365 | 84029G | KNITTED UNION FLAG HOT WATER BOTTLE | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 373 days 15:34:00 |
| 4 | 536365 | 84029E | RED WOOLLY HOTTIE WHITE HEART. | 6 | 2010-12-01 08:26:00 | 3.39 | 17850.0 | United Kingdom | 20.34 | 373 days 15:34:00 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 541904 | 581587 | 22613 | PACK OF 20 SPACEBOY NAPKINS | 12 | 2011-12-09 12:49:00 | 0.85 | 12680.0 | France | 10.20 | 0 days 11:11:00 |
| 541905 | 581587 | 22899 | CHILDREN'S APRON DOLLY GIRL | 6 | 2011-12-09 12:49:00 | 2.10 | 12680.0 | France | 12.60 | 0 days 11:11:00 |
| 541906 | 581587 | 23254 | CHILDRENS CUTLERY DOLLY GIRL | 4 | 2011-12-09 12:49:00 | 4.15 | 12680.0 | France | 16.60 | 0 days 11:11:00 |
| 541907 | 581587 | 23255 | CHILDRENS CUTLERY CIRCUS PARADE | 4 | 2011-12-09 12:49:00 | 4.15 | 12680.0 | France | 16.60 | 0 days 11:11:00 |
| 541908 | 581587 | 22138 | BAKING SET 9 PIECE RETROSPOT | 3 | 2011-12-09 12:49:00 | 4.95 | 12680.0 | France | 14.85 | 0 days 11:11:00 |
541909 rows × 10 columns
Reference Date: 2011-12-10 00:00:00
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| CustomerID | 4372.0 | 15299.677722 | 1722.390705 | 12346.0 | 13812.75 | 15300.5 | 16778.25 | 18287.0 |
| recency | 4372.0 | 91.581199 | 100.772139 | 0.0 | 16.00 | 50.0 | 143.00 | 373.0 |
| CustomerID | recency | |
|---|---|---|
| 0 | 12346.0 | 325.0 |
| 1 | 12347.0 | 2.0 |
| 2 | 12348.0 | 75.0 |
| 3 | 12349.0 | 18.0 |
| 4 | 12350.0 | 310.0 |
| ... | ... | ... |
| 4367 | 18280.0 | 277.0 |
| 4368 | 18281.0 | 180.0 |
| 4369 | 18282.0 | 7.0 |
| 4370 | 18283.0 | 3.0 |
| 4371 | 18287.0 | 42.0 |
4372 rows × 2 columns
| CustomerID | recency | frequency | TotalSum | |
|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 |
| 1 | 12347.0 | 2.0 | 7 | 4310.00 |
| 2 | 12348.0 | 75.0 | 4 | 1797.24 |
| 3 | 12349.0 | 18.0 | 1 | 1757.55 |
| 4 | 12350.0 | 310.0 | 1 | 334.40 |
| ... | ... | ... | ... | ... |
| 4367 | 18280.0 | 277.0 | 1 | 180.60 |
| 4368 | 18281.0 | 180.0 | 1 | 80.82 |
| 4369 | 18282.0 | 7.0 | 3 | 176.60 |
| 4370 | 18283.0 | 3.0 | 16 | 2094.88 |
| 4371 | 18287.0 | 42.0 | 3 | 1837.28 |
4372 rows × 4 columns
CustomerID 0 Recency 0 Frequency 0 Monetary 0 dtype: int64
| CustomerID | Recency | Frequency | Monetary | |
|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 |
| 1 | 12347.0 | 2.0 | 7 | 4310.00 |
| 2 | 12348.0 | 75.0 | 4 | 1797.24 |
| 3 | 12349.0 | 18.0 | 1 | 1757.55 |
| 4 | 12350.0 | 310.0 | 1 | 334.40 |
| ... | ... | ... | ... | ... |
| 4367 | 18280.0 | 277.0 | 1 | 180.60 |
| 4368 | 18281.0 | 180.0 | 1 | 80.82 |
| 4369 | 18282.0 | 7.0 | 3 | 176.60 |
| 4370 | 18283.0 | 3.0 | 16 | 2094.88 |
| 4371 | 18287.0 | 42.0 | 3 | 1837.28 |
4372 rows × 4 columns
| CustomerID | Recency | Frequency | Monetary | R | F | M | |
|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 | 1 | 2 | 1 |
| 1 | 12347.0 | 2.0 | 7 | 4310.00 | 4 | 4 | 4 |
| 2 | 12348.0 | 75.0 | 4 | 1797.24 | 2 | 3 | 4 |
| 3 | 12349.0 | 18.0 | 1 | 1757.55 | 3 | 1 | 4 |
| 4 | 12350.0 | 310.0 | 1 | 334.40 | 1 | 1 | 2 |
| CustomerID | Recency | Frequency | Monetary | R | F | M | RFM_Segment_Concat | |
|---|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 | 1 | 2 | 1 | 1.02.01.0 |
| 1 | 12347.0 | 2.0 | 7 | 4310.00 | 4 | 4 | 4 | 4.04.04.0 |
| 2 | 12348.0 | 75.0 | 4 | 1797.24 | 2 | 3 | 4 | 2.03.04.0 |
| 3 | 12349.0 | 18.0 | 1 | 1757.55 | 3 | 1 | 4 | 3.01.04.0 |
| 4 | 12350.0 | 310.0 | 1 | 334.40 | 1 | 1 | 2 | 1.01.02.0 |
63 0 4 1 12 2 9 3 8 4 4 Name: RFM_Score, dtype: int64
| CustomerID | Recency | Frequency | Monetary | R | F | M | RFM_Segment_Concat | RFM_Score | RFM_Level | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 12346.0 | 325.0 | 2 | 0.00 | 1 | 2 | 1 | 1.02.01.0 | 4 | Requires Attention |
| 1 | 12347.0 | 2.0 | 7 | 4310.00 | 4 | 4 | 4 | 4.04.04.0 | 12 | Can't Loose Them |
| 2 | 12348.0 | 75.0 | 4 | 1797.24 | 2 | 3 | 4 | 2.03.04.0 | 9 | Can't Loose Them |
| 3 | 12349.0 | 18.0 | 1 | 1757.55 | 3 | 1 | 4 | 3.01.04.0 | 8 | Champions |
| 4 | 12350.0 | 310.0 | 1 | 334.40 | 1 | 1 | 2 | 1.01.02.0 | 4 | Requires Attention |
| 5 | 12352.0 | 36.0 | 11 | 1545.41 | 3 | 4 | 3 | 3.04.03.0 | 10 | Can't Loose Them |
| 6 | 12353.0 | 204.0 | 1 | 89.00 | 1 | 1 | 1 | 1.01.01.0 | 3 | Demands Activation |
| 7 | 12354.0 | 232.0 | 1 | 1079.40 | 1 | 1 | 3 | 1.01.03.0 | 5 | Promising |
| 8 | 12355.0 | 214.0 | 1 | 459.40 | 1 | 1 | 2 | 1.01.02.0 | 4 | Requires Attention |
| 9 | 12356.0 | 22.0 | 3 | 2811.43 | 3 | 2 | 4 | 3.02.04.0 | 9 | Can't Loose Them |
| 10 | 12357.0 | 33.0 | 1 | 6207.67 | 3 | 1 | 4 | 3.01.04.0 | 8 | Champions |
| 11 | 12358.0 | 1.0 | 2 | 1168.06 | 4 | 2 | 3 | 4.02.03.0 | 9 | Can't Loose Them |
| 12 | 12359.0 | 7.0 | 6 | 6245.53 | 4 | 4 | 4 | 4.04.04.0 | 12 | Can't Loose Them |
| 13 | 12360.0 | 52.0 | 3 | 2662.06 | 2 | 2 | 4 | 2.02.04.0 | 8 | Champions |
| 14 | 12361.0 | 287.0 | 1 | 189.90 | 1 | 1 | 1 | 1.01.01.0 | 3 | Demands Activation |
Recency Frequency Monetary
mean mean mean count
RFM_Level
Can't Loose Them 24.9 10.0 4100.7 1718
Champions 59.3 3.2 957.5 409
Demands Activation 271.0 1.0 128.0 319
Loyal/Commited 76.6 2.5 684.3 451
Potential 95.8 1.9 478.5 475
Promising 131.5 1.5 338.3 516
Requires Attention 204.5 1.2 231.8 484